/*
 Navicat Premium Data Transfer

 Source Server         : 华为云
 Source Server Type    : MySQL
 Source Server Version : 80032
 Source Host           : 123.60.140.66:3306
 Source Schema         : yrmall_web

 Target Server Type    : MySQL
 Target Server Version : 80032
 File Encoding         : 65001

 Date: 03/08/2023 16:30:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_config
-- ----------------------------
DROP TABLE IF EXISTS `app_config`;
CREATE TABLE `app_config` (
  `id` int DEFAULT NULL,
  `name` varchar(255) NOT NULL COMMENT '配置名称',
  `code` varchar(255) NOT NULL COMMENT '组件编码',
  `metadata` varchar(255) DEFAULT NULL COMMENT '元数据',
  `status` tinyint NOT NULL DEFAULT '0',
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `version` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of app_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for app_layout
-- ----------------------------
DROP TABLE IF EXISTS `app_layout`;
CREATE TABLE `app_layout` (
  `id` bigint NOT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `sort` int NOT NULL,
  `metadata` json DEFAULT NULL COMMENT '元数据',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of app_layout
-- ----------------------------
BEGIN;
INSERT INTO `app_layout` (`id`, `code`, `sort`, `metadata`) VALUES (1, 'mall_title', 0, '{\"title\": \"语若商城\"}');
INSERT INTO `app_layout` (`id`, `code`, `sort`, `metadata`) VALUES (2, 'mall_search_input', 1, NULL);
INSERT INTO `app_layout` (`id`, `code`, `sort`, `metadata`) VALUES (3, 'mall_banner', 2, '{\"bannerList\": [{\"alt\": \"语若商城源码开源啦\", \"img\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/64ac13166e125f2aecb34219.png\", \"url\": \"https://gitee.com/leronx/yuruo-mall.git\", \"type\": 2}]}');
INSERT INTO `app_layout` (`id`, `code`, `sort`, `metadata`) VALUES (4, 'mall_menu', 3, '{\"menuList\": [{\"url\": \"https://gitee.com/leronx/yuruo-mall.git\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01c35765862780e8b43.png\", \"type\": 2, \"title\": \"源码地址\"}, {\"url\": \"/pages/coupon/coupon\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01d35765862780e8b44.png\", \"type\": 1, \"title\": \"领券中心\"}, {\"url\": \"http://www.baidu.com\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01c35765862780e8b41.png\", \"type\": 1, \"title\": \"积分商城\"}, {\"url\": \"http://www.baidu.com\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01d35765862780e8b46.png\", \"type\": 1, \"title\": \"限时秒杀\"}, {\"url\": \"https://gitee.com/leronx\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01c35765862780e8b40.png\", \"type\": 2, \"title\": \"联系作者\"}, {\"url\": \"/pages/hotRecommend/hotRecommend\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01c35765862780e8b3e.png\", \"type\": 1, \"title\": \"热门爆款\"}, {\"url\": \"/pages/me/me\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01c35765862780e8b3f.png\", \"type\": 3, \"title\": \"会员中心\"}, {\"url\": \"/pages/me/me\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01d35765862780e8b45.png\", \"type\": 3, \"title\": \"每日签到\"}, {\"url\": \"http://www.baidu.com\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01c35765862780e8b41.png\", \"type\": 1, \"title\": \"店铺推荐\"}, {\"url\": \"/pages/category/category\", \"icon\": \"https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/6499a01c35765862780e8b42.png\", \"type\": 3, \"title\": \"分类\"}]}');
INSERT INTO `app_layout` (`id`, `code`, `sort`, `metadata`) VALUES (5, 'mall_seckill', 4, NULL);
INSERT INTO `app_layout` (`id`, `code`, `sort`, `metadata`) VALUES (6, 'mall_hot_product', 5, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
